class ModifyingRideAttributes < ActiveRecord::Migration
  
  def self.up
    
    execute "ALTER TABLE rides ADD COLUMN riding_time time AFTER distance;"
    execute "ALTER TABLE rides ADD COLUMN max_speed tinyint unsigned AFTER average_speed;"
    execute "ALTER TABLE rides ADD COLUMN elevation_gain smallint unsigned AFTER bike_id;"
    
    execute "ALTER TABLE rides CHANGE COLUMN distance distance smallint unsigned;"
    execute "ALTER TABLE rides DROP COLUMN time;"
    
  end

  def self.down
  end
end
